package com.ruibang.glass.quality.mapper;

import com.ruibang.glass.quality.domain.resp.GlassBindResp;
import com.ruibang.glass.quality.domain.resp.GlassHqInfo;
import com.ruibang.glass.quality.entity.*;
import com.teaming.cloud.framework2.autoconfigure.dynamic.datasource.annotation.DS;
import com.teaming.cloud.framework2.autoconfigure.mybatisplus.mapper.CommonMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Author: songJinKang
 * @CreateTime: 2023-09-13  10:33
 * @Description: TODO
 * @Version: 1.0
 */
@Mapper
public interface ShelfLotItemMapper extends CommonMapper<ShelfLotItem> {

    List<EveryHourReverseInvestment> getShelfLotItemAll(@Param("startDate") String startDate, @Param("endDate") String endDate);

    @DS("hot2_bc2mes")
    List<EveryHourReverseInvestment> getHourChiselPointTimeByGlassCode(@Param("codes") List<String> glassCodes);

    @DS("cold1_bc2mes")
    List<GlassBind> getGlassBindByColdGlassId(@Param("oldIds") List<String> oldIds);

    @DS("cold1_bc2mes")
    List<GlassBindResp> getNewIdGlassBindAll();

    @DS("hot2_bc2mes")
    List<GlassHqInfo> getHqDetailById(@Param("glassIds") List<String> glassIds);

    @DS("hot2_bc2mes")
    List<GlassHqInfo> getHqDetailAll();

    @DS("hot2_bc2mes")
    List<GlassHqInfo> getHqDetailByDate(@Param("startTime") String startTime, @Param("endTime") String endTime);
}
